Entity Relationships - Sales Pipeline (SALESPIPELINE)

Related Tables

Table Name	Table Description	Primary Keys	Usually Joins From	Join Type	Joins On	Details
SALESPIPELINE	Sales Pipeline Details	SALESPIPELINEID				Stores details of sales pipeline items, including opened, target and closed dates, the value of the sale and the percentage probability of winning the sale.
SALESITEMGROUPING	Sales Item Groupings	SALESITEMGROUPINGID	SALESPIPELINE	Many to one	SALESITEMGROUPINGID	Stores descriptions of groupings used to group sales items.
TRSALESPIPELINE	Trainee-Sales Item Link	TRAINEEID, TRSALESPIPELINEID	SALESPIPELINE	One to Many	SALESPIPELINEID	Links trainees to sales items (e.g. if there are specific trainees that were gained due to a sales win).
SALESPIPELINECOMPETITOR	Sales Item Competitors	SALESPIPELINECOMPETITORID	SALESPIPELINE	One to many	SALESPIPELINEID	Lists competitors for a sales item.
SALESPIPELINEHISTORY	Sales Pipeline History	PIPELINEHISTORYID	SALESPIPELINE	One to many	SALESPIPELINEID	Log of changes made to sales pipeline items, including which user made each change.
M32$_USERS	User Details	USERID	SALESPIPELINE	Many to one	USERID	Details of Maytas users.
SALESTARGET	Sales Targets	SALESTARGETID, USERID	M32$_USERS	One to many	USERID	Lists sales targets for each user per month.